﻿CREATE TABLE [dbo].[InfoForeCast] (
    [IdCustomer]           INT           NOT NULL,
    [IdSegmentPL]          INT           NOT NULL,
    [IdProduct]            INT           NOT NULL,
    [Cod_Cliente]          VARCHAR (20)  NULL,
    [Cod_Producto]         VARCHAR (50)  NULL,
    [IdPeriod]             INT           NOT NULL,
    [IdEntityF]            INT           NOT NULL,
    [Periodo]              VARCHAR (20)  NULL,
    [Descripcion_Product]  VARCHAR (150) NULL,
    [Volumen_ForeCast]     FLOAT (53)    NULL,
    [Costo_ForeCast]       FLOAT (53)    NULL,
    [MonedaCosto_ForeCast] VARCHAR (20)  NULL,
    [Venta_ForeCast]       FLOAT (53)    NULL,
    [MonedaVenta_ForeCast] VARCHAR (20)  NULL,
    [Volumen_Actual]       FLOAT (53)    NULL,
    [Costo_Actual]         FLOAT (53)    NULL,
    [Venta_Actual]         FLOAT (53)    NULL
);

